package com.hcr.regsiter.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface RegisterDao {

    @Update("update face_vector a" +
            " set a.name = #{name}," +
            "a.company = #{company}," +
            "a.nick_name = now()," +
            "a.status = 2," +
            "a.scan_time=now()," +
            "a.submit_time=now() " +
            "where a.id = #{id}")
    int insertRegsiter(String name,String company,String id);

    @Select("select a.image from face_vector a where a.id = #{id}")
    String getImg(String id);

    @Update("update face_vector a set a.status = 1 where a.status = 0 and a.id = #{id}")
    int updateScanStatus(String id);
}
